<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_tr.gif" width="10" height="10"></td>
	</tr>
	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
			<h1 class="body"></A>FAQ - SQuirreL SQL Client.</h1>
			<p>
				<ul>
					<li><a href="#faq10">How do I install SQuirreL SQL Client on Windows Vista?
					<li><a href="#faq9">I get a blank window when running SQuirreL on Fedora Core while
			using Desktop Effects (Compiz) and the Sun JDK. </a></li>
					<li><a href="#faq0">What database systems does SQuirreL work with?</a></li>
					<li><a href="#faq1">What version of the JVM is SQuirreL compatible with?</a></li>
					<li><a href="#faq2">I get a &quot;Segmentation fault&quot; on Linux</a></li>
					<li><a href="#faq3">I get a &quot;Login has timed out&quot; error with Microsoft SQL Server</a></li>
					<li><a href="#faq3_1">I get a &quot;Can't start a cloned
						connection while in manual transaction mode&quot; error
						with Microsoft SQL Server</a></li>
					<li><a href="#faq4">I don't see an object tree with PostgreSQL</a></li>
					<li><a href="#faq5">I get a &quot;NullPointerException&quot; at <TT>BaseSQLEntryPanel.java:23</TT></a></li>
					<li><a href="#faq6">Ingres reports "Error: contsbt:
						ca.edbc.util.EdbcEx: No MST is currently in progress,
						cannot declare another cursor." when I connect and
						nothing is listed under the schema name in the Object
						Tree.</TT></a></li>
					<li><a href="#faq7">Informix reports "The specified table
						(schema.table) is not in the database" when trying to
						view the contents of a table in the current schema.
						</TT></a></li>
					<li><a href="#faq8">I am using SQuirreL 2.x and when I connect to a database 
                                                            I get the following warning message: </a></li>
	<PRE>
	JRE/JDBC Version mismatch

	The driver being used ... is not JDBC N.N compliant. 
	You should consider getting a more recent version of this driver.
	</PRE>
					</ul>
			</p>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>
<p class="menu_divider"></p>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_tr.gif" width="10" height="10"></td>
	</tr>
	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
			<h1 class="body">FAQ - Plugins.</h1>
			<p>
				<ul>
					<li><a href="#plug0">How do I write a plugin?</a></li>
					<li><a href="#plug1">What are these directories &quot;Colin Bell&quot; and
					&quot;Johan Compagner&quot; in the plugins directory?</a></li>
					<li><a href="#plug2">I can't see any &quot;Look and Feel&quot; files.</a></li>
					<li><a href="#plug3">I get a <TT>java.lang.NoClassDefFoundError:
						org/w3c/dom/Node</TT> error when trying to
					validate SQL.</a></li>
				</ul>
			</p>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>
<p class="menu_divider"></p>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_tr.gif" width="10" height="10"></td>
	</tr>
	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
			<h1 class="body">Answers - SQuirreL SQL Client.</h1>
			<h1 class="question"><A NAME="faq10">How do I install SQuirreL SQL Client on Windows Vista?</A></h1>
			<p class="answer">
				Doug Lawry has reported that the following steps are required in order to install SQuirreL SQL Client on Windows Vista.</br>
				<ol>
				<li>Start "cmd.exe" using "Run as administrator"</li>
				<li>Change directory to the file location</li>
				<li>Run "java -jar squirrel-sql-2.5.1-install.jar"</li>
				</ol>
			<h1 class="question"><A NAME="faq9">I get a blank SQuirreL 2.4 window when running on Fedora Core while
			using Desktop Effects (Compiz) and Sun Java 1.5.  What gives? </A></h1>
			<p class="answer">
			Andrew Melton has reported that disabling Desktop Effects (and using metacity) solved the problem.  Furthermore,
			he also reports that after re-enabling Desktop Effects SQuirreL still renders correctly.  Additionally, 
			<a href="http://bugs.sun.com/bugdatabase/search.do?process=1&category=&bugStatus=&subcategory=&type=&keyword=6429775">this Java bug </a> 
			seems at least related to if not the same problem.
			</p>
			<h1 class="question"><A NAME="faq0">What database systems does SQuirreL work with?</A></h1>
			<p class="answer">In theory SQuirreL should work with any DBMS that has a JDBC 2.0 driver. However not all
			drivers/DBMS's are fully complient with the JDBC 2.0 specification. People have reported SQuirreL
			working with the following:</p>
			<UL>
			<LI><A HREF="http://axion.tigris.org/">Axion Java RDBMS</A>.</LI>
			<LI><A HREF="http://www.daffodildb.com/one-dollar-db.html">Daffodil (One$DB)</A></LI>
			<LI><A HREF="http://db.apache.org/derby/">Apache Derby </A> (formerly Cloudscape) <a href="http://db.apache.org/derby/integrate/SQuirreL_Derby.html"> Using SQuirreL SQL with Derby</a> (by Susan Cline)</LI>
			<LI><A HREF="http://www.fujitsu-siemens.com/rl/products/software/sesamsql.html">Fujitsu Siemens SESAM/SQL-Server</A>
						with the <A HREF="http://www.fujitsu-siemens.com/rl/products/software/sesamsqljdbc.html">SESAM/SQL</A> JDBC driver.
			<LI><A HREF="http://sourceforge.net/projects/firebird/">Firebird</A> with the JayBird JCA/JDBC Driver.</LI>
                        <LI><A HREF="http://www.frontbase.com/">FrontBase</A></LI>
			<LI><A HREF="http://hsqldb.sourceforge.net/">HSQL</A>.</LI>
			<LI><A HREF="http://hsql.sourceforge.net/">Hypersonic SQL</A>.</LI>
			<LI><A HREF="http://www.h2database.com/">H2</A></LI>
			<LI><A HREF="http://www.ibm.com/">IBM DB2</A> for Linux, OS/400 and Windows.</LI>
			<LI><A HREF="http://www.informix.com/">Informix</A>.</LI>
			<LI><A HREF="http://www.ingres.com/">CA Ingres</A> 2.6 SP2 with EDBC driver v1.8 (probably works with Caribou Lake driver too).</LI>
			<LI><A HREF="http://www.instantdb.com/">InstantDB</A>.</LI>
			<LI><A HREF="http://www.interbase.com/">Interbase</A> with the <A HREF="http://www.interbase.com/">Interclient</A> JDBC driver.</LI>
			<LI><A HREF="http://mckoi.com/database/">Mckoi SQL</A>.</LI>
			<LI><A HREF="http://www.microsoft.com">Microsoft Access</A> with the JDBC/ODBC bridge.</LI>
			<LI><A HREF="http://www.microsoft.com">Microsoft SQL Server</A> with the Microsoft,
					<A HREF="http://www.weblogic.com">WebLogic</A> and
					<A HREF="http://jtds.sourceforge.net">jTDS</A>
					JDBC drivers.</LI>
			<LI><A HREF="http://www.mimer.com/">Mimer SQL</A></LI>
			<LI><A HREF="http://www.mysql.com">MySQL</A> with the <A HREF="http://mmmysql.sourceforge.net/">MM MySQL</A> JDBC driver.</LI>
			<LI><A HREF="http://www.oracle.com">Oracle 8i, 9i and 10g</A> with the Oracle thin and OCI drivers.</LI>
			<LI><A HREF="http://www.pointbase.com">Pointbase</A>.</LI>
			<LI><A HREF="http://www.postgresql.org">PostgreSQL 7.1.3 and higher.</A>.</LI>
			<LI><A HREF="http://www.progress.com">Progress OpenEdge 10.1x</A>.</LI>
			<LI><A HREF="http://www.sapdb.org">SAPDB</A>.</LI>
			<LI><A HREF="http://www.sybase.com">Sybase</A> with the <A HREF="http://www.sybase.com">JConnect</A> JDBC driver.
					There are currently some issues with Sybase JConnect 5.5 and
					SQuirreL 1.1 although JConnect 4.5 seems to work.</LI>
			<LI><A HREF="http://www.sunopsis.com/corporate/us/products/jdbcforxml/">Sunopsis XML Driver (JDBC Edition)</A>.</LI>
			<LI><A HREF="http://www.ncr.com/en/solutions/data_warehousing/dataware.htm">Teradata Warehouse</A></LI>
			<LI><A HREF="http://www.thinksql.co.uk">ThinkSQL RDBMS</A>.</LI>
			</UL>
			<p class="answer">Please send us an <A HREF="mailto:manningr@users.sourceforge.net">email</A> if you have used SQuirreL
			successfully with other products.</p>
			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="faq1">Which version of the JVM is SQuirreL compatible with?</A></h1>
			<p class="answer">Different versions of SQuirreL have different minimum JVM version requirements.
			The following table provides a summary of the version requirements:<nr/>
			<table align="center" border="2" cellpadding="5">
			<th>SQuirreL Version</th><th>Minimum JVM Version</th>
			<tr align="center">
				<td>2.4+</td><td>1.5</td>
			</tr>			
			<tr align="center">
				<td>2.0 - 2.3.x</td><td>1.4.2</td>
			</tr>
			<tr align="center">
				<td>1.1 Final</td><td>1.3.1</td>
			</tr>
			</table>
			</p>
			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="faq2">I get a &quot;Segmentation fault&quot; on Linux</A></h1>
			<p class="answer">Early versions of the Sun 1.3.0 VM on Linux throw a segmentation fault when running SQuirreL. Either
			update to the latest 1.3.1 VM or pass the -classic flag to the Java executable - i.e.</p>
			<p class="code">java -classic -cp...</p>

			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="faq3">I get a &quot;Login has timed out&quot; error with Microsoft SQL Server</A></h1>
			<p class="answer">Early beta versions of the Microsoft type 4 JDBC driver had a bug which would cause this
			error when trying to connect. Go to the General Tab in the Global Preferences dialog and
			change the SQL Login Timeout to 0.</p>

			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="faq3_1">I get a &quot;Can't start a
					cloned connection while in manual transaction mode&quot;
					error with Microsoft SQL Server</A></h1> <p
			class="answer">When connecting to Microsoft SQL Server with
			auto-commit off or changing auto-commit to false for an existing
			connection you may get this error. To stop it from occuring enable
			the 'selectmethod=cursor' driver property in the alias.</p>

			<p><A HREF="#top">Top</A><HR SIZE=1></HR></P>

			<h1 class="question"><A NAME="faq4">I don't see an object tree with PostgreSQL</A></h1>
			<p class="answer">Versions of PostgreSQL prior to 7.1.3 didn't supply sufficent metadata to build the object
			tree in SQuirreL. A fix has been put into SQuirreL so that it would work with PostgreSQL 7.1.2.</p>

			<p><A HREF="#top">Top</A><HR SIZE=1></HR></P>

			<h1 class="question"><A NAME="faq5">I get a &quot;NullPointerException&quot; at <TT>BaseSQLEntryPanel.java:23</TT></A></h1>
			<p class="answer">This is a known problem with JDK1.3.0 on some platforms. Upgrade your Java version to 1.3.1 or better.</p>

			<p><A HREF="#top">Top</A><HR SIZE=1></HR></P>

			<h1 class="question"><A NAME="faq6">Ingres reports "Error: contsbt:
						ca.edbc.util.EdbcEx: No MST is currently in progress,
						cannot declare another cursor." when I connect and
						nothing is listed under the schema name in the Object
						Tree</A></h1>
			<p class="answer">Right-click on the schema in the explorer and select refresh, objects should appear as normal.</p>
			<p><A HREF="#top">Top</A></P>

			<h1 class="question"><A NAME="faq7">Informix reports "The specified
				table (schema.table) is not in the database" when trying to
				view the contents of a table in the current schema</A></h1>
			<p class="answer">This is a bug in earlier versions of the Informix JDBC
						driver and is known to be fixed in version 9.4 of
						Informix and version 2.21 of the Informix JDBC driver.</p>
			<p><A HREF="#top">Top</A><HR SIZE=1></HR></P>
			<h1 class="question"><A NAME="faq8">I am using SQuirreL 2.x and when I connect to a database 
                                                            I get the following warning message: </A></h1>
	<PRE>
	JRE/JDBC Version mismatch

	The driver being used ... is not JDBC N.N compliant. 
	You should consider getting a more recent version of this driver.
	</PRE>
			<p class="answer">It's telling you that your JRE version is much newer than your driver's supported JDBC version. In general,
					  it's hard to tell how well tested an older driver is with a newer JVM(1.4+). The odds are good that the newer JVM
					  wasn't available when the older driver was written. So the warning message is there to let you know that you
					  aren't getting the most efficient use from SQuirreL 2.x and your database driver. SQuirreL 2.x requires JVM 1.4
				          or higher so your choices are limited there. Upgrade your JDBC driver if possible - if not, then you can 
					  disable the warning.  To disable it go to Global Preferences -> General and uncheck the checkbox next to
                                          <b><i>Warning for JRE/JDBC Version Mismatch</b></i></p></p>


			<p><A HREF="#top">Top</A></P>

		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>
<p class="menu_divider"></p>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_tr.gif" width="10" height="10"></td>
	</tr>
	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
			<h1 class="body">Answers - Plugins.</h1>
			<h1 class="question"><A NAME="plug0">How do I write a plugin?</A></h1>
			<p class="answer">There is some information in the document 
			<a href="http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/plugins.html?revision=1.1">plugins.html</a> 
			which you can find in the docs directory within your SQuirreL program directory. This
			document badly needs a lot of work and its on our todo list. You can also
			look at the existing plugins to see how they've done things.</p>
			<p class="answer">If you have an idea for a plugin just send a message to the SQuirreL Developers list giving a
			brief description. This helps to ensure that two people don't develop the same plugin.</p>
			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="plug1">What are these directories &quot;Colin Bell&quot; and
						&quot;Johan Compagner&quot; in the plugins directory?</A></h1>
			<p class="answer">Some people have reported these directories appearing when running JDK 1.3 on
			Windows 2000. It appears to be a problem with the Hotspot VM. Passing the -classic flag
			to the java executable fixes the problem - i.e.</p>
			<p class="code">java -classic -cp...</p>
			<p><A HREF="#top">Top</A><HR SIZE=1></HR></p>

			<h1 class="question"><A NAME="plug2">I can't see any &quot;Look and Feel&quot; files.</A></h1>
			<p class="answer">This can be caused by the <A HREF="#plug1">What are these directories &quot;Colin Bell&quot; and
						&quot;Johan Compagner&quot; in the plugins directory?</A> problem.</p>

			<p><A HREF="#top">Top</A></P>

			<h1 class="question"><a name="plug3">I get a java.lang.NoClassDefFoundError:
						org/w3c/dom/Node error when trying to
					validate SQL.</a></h1>

			<p class="answer">If you use the SQL Validator plugin with JDK 1.3 you will need a JAXP 1.1 XML compliant
						parser such as <A HREF="http://xml.apache.org/dist/xerces-j/">xml-xerces</A>
						or the <A HREF="http://java.sun.com/xml/jaxp/index.html">
						JAXP 1.1 reference implementation</A>. Copy the jar files from your XML parser to the
						directory &lt;squirrel-sql&gt;/plugins/sqlval/lib. For
						xml-xerces this should be xerces.jar and for JAXP 1.1 reference implementation this should be
						crimson.jar and jaxp.jar.</p>

			<p><A HREF="#top">Top</A></P>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>
	<tr>
		<td width='10' height='10'><img border="0" src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img border="0" src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img border="0" src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>
